insert overwrite table spmi_dwd.dwd_ibk_fund_record_report_base_dt partition(dt)
select
id,
account_id,
account_no,
network_id,
network_code,
network_name,
parent_network_id,
parent_network_code,
parent_network_name,
financial_center_id,
financial_center_code,
financial_center_name,
manage_region_code,
manage_region_name,
cfinancial_center_id,
cfinancial_center_code,
cfinancial_center_name,
gather_network_code,
gather_network_name,
trade_type,
fee_type,
fee_type_code,
fee_type_name,
fee_item_type,
fee_item_type_code,
fee_item_type_name,
`date`,
amount,
is_enable,
business_model_id,
is_delete,
create_by,
update_by,
create_by_name,
update_by_name,
create_time,
update_time,
version,
sort,
last_update_time_sync,
source_type,
dt
from spmi_ods.ibk_fund_record_report
where dt= '{{ execution_date | cst_ds }}'
distribute by dt
